DELIMITER //

create procedure spemp34(IN uemp_id int)
BEGIN
 select *  from emp_mgmt where emp_id=uemp_id;
END //

DELIMITER  ;

//call spemp34(107);


DELIMITER //

create procedure spempdate(IN uyear int)
BEGIN
 select *  from emp_mgmt where YEAR(own_prod)=uyear;
END //

DELIMITER  ;

call spempdate(2009);